Skip to main content

IMPOWER function

The IMPOWER function returns a complex number raised to a power.

Parts of a IMPOWER formula​

The IMPOWER formula is formatted as =IMPOWER(complex_base, exponent).

Sample formulas​

IMPOWER("4-3i",0.5)

IMPOWER(A2,B2)

IMPOWER("2j",-7)

Notes​

  • The exponentiation of a complex number is defined as follows:
    • (a+bi)^n^ = r^n^(cosθ + isinθ), where
    • r = √(x^2^ + y^2^) and θ = arctan(b/a)

Examples​

AB
1FormulaResult
2=IMPOWER("5+2i", 3)65+142i
3=IMPOWER("-1-j", -1)-0.5+0.5j
4=IMPOWER("0.732-5.349i", -0.138)0.776914096672106+0.155872432042838i

COMPLEX: The COMPLEX function creates a complex number, given real and imaginary coefficients.

IMREAL: Returns the real coefficient of a complex number.

IMAGINARY: Returns the imaginary coefficient of a complex number.

POWER: Returns a number raised to a power.